<?php
include("include/db.php");

$in_cat		= $_GET['cat'];
if($in_cat != ''){$cat_from = ", film_cat "; $cat_sql = "  AND films.film_id = film_cat.film_id AND film_cat.cat_id='$in_cat' ";}

//$in_country		= $_GET['country'];
//if($in_country != ''){$country_sql = " AND films.country='$in_country' ";}

$in_venue		= $_GET['venue'];
if($in_venue != ''){$venue_sql = " AND screenings.venue_id='$in_venue' ";}

?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <meta http-equiv="Content-Type" content="text/html"/>
    <meta charset="utf-8">

    <title>Sebastopol Documentary Film Festival - <?php echo $myrow['title'];?></title>
    <script src="Scripts/AC_RunActiveContent.js" type="text/javascript">
</script>

<link type="text/css" href="main-events.css" rel="stylesheet" />
    
<style type="text/css">
	
	body{color: black;}
	
	a{color: black;}
	.clear{clear: both;}


    .style1 {color: #000000}
    .style3 {
    color: black;
    font-weight: bold;
    font-style: italic;
    }
    
    div.rightbody{
    	background-color: white;
    	color: black;
    
    }

</style>



</head>
<body class="sub">
<div id="container">
<div id="wrapper">
  <div id="left">
    <div class="logo">
      <p><a href="/"><img src="images-events/logo.gif" alt="Sebastopol Documentary Film Festival" width="211" height="239" /></a></p>
    </div>
     	
     	<?php include "include/menu.php"; ?>
    
    <!-- end main nav -->
    <br class="clear" />
  </div>
  <!-- end left -->
  <div id="right">
    <div class="head">
    </div>
    <!-- end banner -->
    <div id="content">

                
                
         <h1>Venue List</h1>   

              <?php
	$result = mysql_query("SELECT venue_name, venue_id, venue_address FROM venues ORDER BY venue_name", $db);
      	while ($myrow = mysql_fetch_array($result, MYSQL_ASSOC)) { 
      	if($class == 'row2'){$class = 'row1';}else{$class = 'row2';}
      	?>
      	
      	<h4><a href="venue.php?id=<?php echo $myrow["venue_id"];?>"><?php echo $myrow["venue_name"];?></a></h4>
      		<p style="padding-left:15px"><?php echo $myrow["venue_address"];?></p>

            		  
   <?php $nolist = '';  echo "<br>"; } ?>              


         

                </tr>
              </tbody>
            </table>
              
                
      <br class="clear" /> 
    </div><!-- end content -->
    <div id="footer">
   <p> &copy;2009 Sebastopol Center for the Arts and Trinity Productions. All rights reserved.</p>
    </div>
  </div><!-- end right -->
  </div><!-- end wrapper -->
  <br class="clear" />
</div><!-- end container -->
</body>
</html>
